package com.yinhai.cp_nzw.mapper;

import com.yinhai.cp_nzw.bean.CP;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

@Mapper
@Component
public interface IndexMapper extends MyBaseMapper<CP>  {

    @Select("select blue_ball_1 as ball,count(blue_ball_1) as total from cp GROUP BY blue_ball_1 order by blue_ball_1 asc")
    List<Map<String, Object>> statisticsBlue();
}
